UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vk17Rw5m6e1QYjV5jdotqeGCWBWz5fbStunEL6T/8aU='
WHERE
key_id = '27c0ffa4ceb46e310c003839c64b2466175c9c72d10510ac960bddeb69a68019'
AND (
token = 'Vk17Rw5m6e1QYjV5jdotqeGCWBWz5fbStunEL6T/8aU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)