UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eC5i4yPwL8rO3QQEzsMC2FJdGGYM4yPgWcGafmZBW44='
WHERE
key_id = '220b886af1b05b27d6e4531ef6b2312f490203a07bb3cf68c6504b328a756426'
AND (
token = 'eC5i4yPwL8rO3QQEzsMC2FJdGGYM4yPgWcGafmZBW44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)