UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdXA2OBDc+ac+zKSTmsYkK8pcxFhlEuvPwtMmOJWEWo='
WHERE
key_id = '2534d8bc1a780e8e3fcf05b2d0e73f8a311100ceb663ce6820192373b8c628d8'
AND (
token = 'zdXA2OBDc+ac+zKSTmsYkK8pcxFhlEuvPwtMmOJWEWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)