UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lLiJ0JE2COvPXw9l0plH+ZfyM47lkxv2J2Jtdzi/Iik='
WHERE
key_id = '1175103b66062d8ad2cd83e8c3ce9e3bbaa901ca72fa60e808188f9cc7eee080'
AND (
token = 'lLiJ0JE2COvPXw9l0plH+ZfyM47lkxv2J2Jtdzi/Iik='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)