UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8XGT2wdUjZuNUQl//h7oQx/52R7oPofhV0EuDBI8mc4='
WHERE
key_id = 'c59e5d2742495e3e905cee1a4160ad793d2d99ebdd1f9f5d7225ba62b94dea70'
AND (
token = '8XGT2wdUjZuNUQl//h7oQx/52R7oPofhV0EuDBI8mc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)