UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sNLvnKJBtVVy6qITK9bPcs5i2BWKTSFC2iRzDH9xkNk='
WHERE
key_id = 'b7e02ffdd6323cfd191e5cb976dd32e367c777a384cb2e1e7694c1cdde8780c5'
AND (
token = 'sNLvnKJBtVVy6qITK9bPcs5i2BWKTSFC2iRzDH9xkNk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)