UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8yfXdAp3h+21kbzxCO4qqMdZMFStyEzvYDC+AKNMWuI='
WHERE
key_id = '4811a3c1e58bf4027999b8eb9cd061198c695fcdf93aa1d9a4401b0ee5d6a4c8'
AND (
token = '8yfXdAp3h+21kbzxCO4qqMdZMFStyEzvYDC+AKNMWuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)