UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfF5pPReVN/Tt/ZmnaQSwQHYaA6Ky1BttPGqZEpc1pI='
WHERE
key_id = 'aafc8b6cd9c4f7469dc033276b05de0672b761e66203ca52b88f727dbfa8f2b1'
AND (
token = 'zfF5pPReVN/Tt/ZmnaQSwQHYaA6Ky1BttPGqZEpc1pI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)