UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qUaL3lJsBMsmxWVdl2yD5MY0hd/92L8hyJknbVwbc8s='
WHERE
key_id = 'd3e93953f9755b81f08f6cd8fb886414ad560558faf12afb3b2455a1d3e7e8dd'
AND (
token = 'qUaL3lJsBMsmxWVdl2yD5MY0hd/92L8hyJknbVwbc8s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)