UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hbgSFY91Tbyc/18bAyzFHZCYPJRhSp4vfXGOb40ckzE='
WHERE
key_id = 'd1631fd89bbc43a9f665fc311afcaa113f020981c200da1fe7e21b16e241561b'
AND (
token = 'hbgSFY91Tbyc/18bAyzFHZCYPJRhSp4vfXGOb40ckzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)