UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bdBGzPJZqct5hv2H0LKnJda7Uf4Ms80cSuXCIwmm3+4='
WHERE
key_id = 'e52ac4cb173213f4013428b7162469ccfc288fc3f2a52848263b5c8b9363a9b6'
AND (
token = 'bdBGzPJZqct5hv2H0LKnJda7Uf4Ms80cSuXCIwmm3+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)