UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dLPGJm2nOqxV1+1fynTyjpndk+qeJgxEvlwgUfiiaN0='
WHERE
key_id = '524034690b67023e8d1f3bbb9746d66432b9bc45dfbeb3247124563ba31bf620'
AND (
token = 'dLPGJm2nOqxV1+1fynTyjpndk+qeJgxEvlwgUfiiaN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)