UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5XpZFZvcZM9XubAZVZq45+1m6MDv/GRdkllRFuVkHYQ='
WHERE
key_id = 'd6e42ec7ef697482e5d642a4f94430bc9f3143ffe0b6cf28da5fdd1d118a448a'
AND (
token = '5XpZFZvcZM9XubAZVZq45+1m6MDv/GRdkllRFuVkHYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)