UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KtJYlP/d3KgC6sZPWm9Lm/400/5yM0beqf/Njh6LLZI='
WHERE
key_id = 'b701529f4d9aefbc1a18c2ff9fdc840afa2de018cb1963e4fe969aa21b8160bf'
AND (
token = 'KtJYlP/d3KgC6sZPWm9Lm/400/5yM0beqf/Njh6LLZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)