UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+q6uWyTSGDTZeCKgNoe4SSL1vJ9uTn96kwsZWlWCsyw='
WHERE
key_id = '9e051bb55386fd429e3caab2d5d3e2c931bbc05d2c863afb0e0de4f162a0ea55'
AND (
token = '+q6uWyTSGDTZeCKgNoe4SSL1vJ9uTn96kwsZWlWCsyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)