UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nBHaT7ztoo7Y3jYK3lDfVKJGodxI6yk5saN1ec6z8n4='
WHERE
key_id = 'cfb44083ac0d7df270ac330424d906d85cddce8e3e3a217a926e5d725908ce7f'
AND (
token = 'nBHaT7ztoo7Y3jYK3lDfVKJGodxI6yk5saN1ec6z8n4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)