UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sKrIrCNPokbt0Z0zreG8IyJ8ga69MDYI9vn8SSQHynE='
WHERE
key_id = '8b9ffa5c8632f15b2cf91dce9629536e5300f22fb195d773f912235d30ac98f0'
AND (
token = 'sKrIrCNPokbt0Z0zreG8IyJ8ga69MDYI9vn8SSQHynE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)