UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1kBR6X4AEAaraR1fv7gL5owbk/RobKJaOMD6rYIIexE='
WHERE
key_id = '5f62f74406e5069773216a6b5ea905759a14d12fd0be4f00d8d0c7fe6bc09ece'
AND (
token = '1kBR6X4AEAaraR1fv7gL5owbk/RobKJaOMD6rYIIexE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)