UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'itNJoebcsbrn+MoEMCCT5k0IKFrp0EG7e7UM/ZlL2tA='
WHERE
key_id = 'd5ab964ad1cc294b40be94f0f74fa758d61a93abbcebc94a6aa070617d90eaa9'
AND (
token = 'itNJoebcsbrn+MoEMCCT5k0IKFrp0EG7e7UM/ZlL2tA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)