UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrPdjwrba5kE/pOElI/fp7MSKST8BjBoM4wkautWKzM='
WHERE
key_id = '6b724ae6b077694f4a7ad0163a3274316df3ce7a99a56801766daae3a95155b6'
AND (
token = 'ZrPdjwrba5kE/pOElI/fp7MSKST8BjBoM4wkautWKzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)