UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ms4ioedEz4LHqPB4U/3fMZlR/AhX7v6SfLpf06nuwHA='
WHERE
key_id = '2609eca2e27e8906f2f30f271de5276b59d6a47ec65a4692b179a9406db2b2fd'
AND (
token = 'ms4ioedEz4LHqPB4U/3fMZlR/AhX7v6SfLpf06nuwHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)