UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pK4wWYFjXn61ebVzhYMOIyF8SguBRQPJGH+twVUEK/Y='
WHERE
key_id = '1a48456c72322f24fe4813413b881fd1cf1b8b8f3b1c3fc543a709d1421b5cfe'
AND (
token = 'pK4wWYFjXn61ebVzhYMOIyF8SguBRQPJGH+twVUEK/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)