UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIDrhYrkZPR1xcpA/BpWwnDF98WkgmTm3PDYL2QVH1U='
WHERE
key_id = '04c6e961a5932883ede5e2c1e3e26bb3a46fcbc785f7d75c842765f5f9b99ead'
AND (
token = 'ZIDrhYrkZPR1xcpA/BpWwnDF98WkgmTm3PDYL2QVH1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)