UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iSgfDSNMOpDUHjoSo+1CJjJi4mu16fWWjcm50pZKd5k='
WHERE
key_id = 'c9a961d14f96f61c357d1d1fa51907a4d4ad59771f34d38032d67bb936033e39'
AND (
token = 'iSgfDSNMOpDUHjoSo+1CJjJi4mu16fWWjcm50pZKd5k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)