UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lpxwDh90U3jrgfU247/TnFYgA4yTaum/YXd0/Ds+VhA='
WHERE
key_id = 'd7b9648da03c6fcf60c72285b3719fbbb5c0bf6293b75e481769cad7c67a3fdc'
AND (
token = 'lpxwDh90U3jrgfU247/TnFYgA4yTaum/YXd0/Ds+VhA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)