UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L80mQYWxMou/lnS5H7wnljMBQxiJ47V458x82spLbLo='
WHERE
key_id = 'c9f3fe4e8a22eea1cd30b565345c4312203f0ebe7ddfa15818df48f7476c71ee'
AND (
token = 'L80mQYWxMou/lnS5H7wnljMBQxiJ47V458x82spLbLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)