UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXrevXE2p5X+HAY2xi6PSk8NwTYFwM7jRBZI8H4BTIU='
WHERE
key_id = '1ce967b8d80f8f6534d5f3e8c0d847089627c86dc5d27ea3b0b3885d1ad2388a'
AND (
token = 'JXrevXE2p5X+HAY2xi6PSk8NwTYFwM7jRBZI8H4BTIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)