UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xGOGyE/HtdWdbYszbfsup/43tq/9aEYIrLGDpC9qT3o='
WHERE
key_id = '46ea830093e984b006d700f1efc03e37383cf60f3a2cac330f1c6fe99031c6e2'
AND (
token = 'xGOGyE/HtdWdbYszbfsup/43tq/9aEYIrLGDpC9qT3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)