UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9QEHK9GwF+1V+nrCabh1lm5Zay2WK9uPYCqxx6/YIA='
WHERE
key_id = 'c545163b67cbaf02f8fc665a6a4261fb1b2a72b4f7cca920fb154bfc28989b12'
AND (
token = 'a9QEHK9GwF+1V+nrCabh1lm5Zay2WK9uPYCqxx6/YIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)