UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xRyMsJwlxHDOoewsOD0IhvMpLJcnaFbC1PGXckpkf08='
WHERE
key_id = '10479522ba8bad6d7aa838dec5155b180513b2e1bcad25d9e453c5732807ea1d'
AND (
token = 'xRyMsJwlxHDOoewsOD0IhvMpLJcnaFbC1PGXckpkf08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)