UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p1IBB7g317NjS0HGzh4+830K/Z8fi2C7ZpBM8ohFfLI='
WHERE
key_id = 'bdc1acb22b67d9c07c5ce8b3b7350c255d4560edd78b707cf863f6423f685b5b'
AND (
token = 'p1IBB7g317NjS0HGzh4+830K/Z8fi2C7ZpBM8ohFfLI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)