UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJThK6TPY56cV3+ctpmcdDnM/FEKcv5maiLPsP7BcJA='
WHERE
key_id = '4dc70582e6ec400dc51049f2af5f73ff1f90e6087b6e037c692a150dfde5f753'
AND (
token = 'zJThK6TPY56cV3+ctpmcdDnM/FEKcv5maiLPsP7BcJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)