UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0cY897LRsz1v5W2LVBABhHxjJMPPicmajUKH2anEs5k='
WHERE
key_id = '41ec328bb866616eed859e24461be776824e4f24adc78b5efaa8990479fcc828'
AND (
token = '0cY897LRsz1v5W2LVBABhHxjJMPPicmajUKH2anEs5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)