UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EQXK7GtwDl5LjwaX86VdqI4LR2RO5WX/U4m90jjEtfc='
WHERE
key_id = '7fd4adf8fb231b304cedf9f88cad35ea287bd611767d2925997bb6aec2141d5a'
AND (
token = 'EQXK7GtwDl5LjwaX86VdqI4LR2RO5WX/U4m90jjEtfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)