UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BTXE5WXG42GBONFKdRYHqkXbArTQPdRgRiWtemWfGU='
WHERE
key_id = '40c96fb945ba0114bba4a0f7eb9556304b036164abefdfdc73b4f7083ed60af1'
AND (
token = '1BTXE5WXG42GBONFKdRYHqkXbArTQPdRgRiWtemWfGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)