UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RhYK9EVDf+An8XC3Mr+OiyDadgJLYdIu1ibqT1Tocq0='
WHERE
key_id = '37b452a5edfc76e24a0b2f0b95dc68ed1d0a3a6b130bcb23b7aa7d3c6fad0f97'
AND (
token = 'RhYK9EVDf+An8XC3Mr+OiyDadgJLYdIu1ibqT1Tocq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)