UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fXYiIBxiJXlCf4g3lxcUlozU2s2tmVf9Dv6PukkJzsc='
WHERE
key_id = 'e320c961aee4a09c26cf6cf68ec2d86067da4cdc43c00993fcf45778c7093a60'
AND (
token = 'fXYiIBxiJXlCf4g3lxcUlozU2s2tmVf9Dv6PukkJzsc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)