UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x7zGpyl3lsm9IDXHidTNmYVn1Du9Bep4zRprA3VYqkU='
WHERE
key_id = '81d6b79f5549c36900f38e12b63ddd972d39bbd475120115c67f27c10b00b26a'
AND (
token = 'x7zGpyl3lsm9IDXHidTNmYVn1Du9Bep4zRprA3VYqkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)