UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zECSV9PWrUKH/jxWvJLrohM4X8dWMc2WPcgEj/609K8='
WHERE
key_id = 'c58b3729ba402bf0229c0cba2e407edea32a35ae7913b84a546144efdfb45213'
AND (
token = 'zECSV9PWrUKH/jxWvJLrohM4X8dWMc2WPcgEj/609K8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)