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